package com.data.center.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.data.center.entity.Dictionary.SpecializedTechnicalJob;
import com.data.center.entity.OrganizationTag;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author DN
 * @description: 专业技术职务编码字典服务类CD000009
 * @date 2023/11/27 16:06
 */
@Mapper
public interface SpecializedTechnicalJobMapper extends BaseMapper<SpecializedTechnicalJob> {

    @Select("SELECT * FROM specialized_technical_job WHERE code = #{code}")
    SpecializedTechnicalJob getByCode(@Param("code") String code);

    @Select("SELECT * FROM specialized_technical_job WHERE name LIKE #{name}")
    List<SpecializedTechnicalJob> searchByName(@Param("name") String name);

}